Model Table ACCOUNT ATTRIBUTE 1

This model dimension represents financial Accounting Attributes related to code Account. There is no core dimension aviailable as source. The information about all accounting attributes related to all code parts is retrieved via a special non-dimenional source provided by the responsible product team. There is a dedicated Tabular Data Source that filters out the Account specific attribute information and it considers the load configuration related to Accounting Attribute no 1 for Account. (each code part support 5 separate attribute definitions).

Attributes

Attribute Description
Attribute Value The attribute value identity represented by the attribute value concatenated with the description of the attribute value
Attribute Value Code The attribute value
Attribute Value Desc The description of the attribute value.

Attributes

Attribute Description (where applicable)
Attribute ValueAttribute1 value + Description
Attribute Value CodeAttribute1 value
Attribute Value DescDescription of Attribute1 value

USED BY MODEL(S)

Model Name
General Ledger

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACCOUNT ATTRIBUTE 1DIM_ACC_ATTR1_ACCOUNT_TMDIM_ACC_ATTR_BIA, LUP_ACC_ATTRIBUTE_TCDIM_ACC_ATTR_1_ACCOUNTOn Line